8b7911e0ecdfd873b71b9fe8f23c34b4739925d4,tests/frontend/org/voltdb/regressionsuites/TestSQLFeaturesNewSuite.java,TestSQLFeaturesNewSuite,testTableLimitAndPercentage,#,142
Before Change
vt = client.callProcedure("@AdHoc", "select count(*) from CAPPED0").getResults()[0];
validateTableOfScalarLongs(vt, new long[] {0});
verifyProcFails(client, "CONSTRAINT VIOLATION\\s*Table CAPPED0 exceeds table maximum row count 0",
"CAPPED0.insert", 0, 0, 0);
vt = client.callProcedure("@AdHoc", "select count(*) from CAPPED0").getResults()[0];
validateTableOfScalarLongs(vt, new long[] {0});
After Change
public void testTableLimitAndPercentage() throws Exception {
System.out.println("STARTING TABLE LIMIT AND PERCENTAGE FULL TEST......");
Client client = getClient();
VoltTable vt = null;
Exception e = null;
if(isHSQL()) {
return;
}
// When table limit feature is fully supported, there needs to be more test cases.
// generalize this test within a loop, maybe.
// Test max row 0
vt = client.callProcedure("@AdHoc", "select count(*) from CAPPED0").getResults()[0];
validateTableOfScalarLongs(vt, new long[] {0});
e = null;
try {
vt = client.callProcedure("CAPPED0.insert", 0, 0, 0).getResults()[0];
} catch (ProcCallException ex) {
e = ex;
assertTrue(ex.getMessage().contains("CONSTRAINT VIOLATION"));